[dbo].[BAERosterManagementSetUserActive]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAERosterManagementSetUserActive

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@uid	varchar(10)	10

SQL Script

/*
sets the status when a roster manager sets a user to active.
*/
CREATE PROC [dbo].[BAERosterManagementSetUserActive]
@uid VARCHAR(10)
AS
UPDATE Name SET STATUS = 'A' WHERE ID = @uid;

GO

Uses

[dbo].[Name]
dbo